Policies In Use{{ifne=pnam; ({{item=pnam}})}}

{{frmt=html}}{{name=Policies In Use}}{{lang=en}}{{cols=name=Name%3Bheld=In Use%3Bwait=In Use}}{{cach=hold:300}} {{qstr=sql;select max(policyName),max(policyID),count(inuseUserID),sum(inuseWaiting) from KSInuse,KSPolicies where inusePolicyID IS NOT NULL AND inusePolicyID=policyID group by policyName,policyID}} {{tmpl=styl; }} Policies In Use{{ifne=pnam; ({{item=pnam}})}} {{ifeq=fram;{{tmpl=btop}}

{{tmpl=ftop}} {{tmpl=rtop}} }}

Policies In Use{{ifne=pnam; ({{item=pnam}})}}{{ifne=icnc; }}

Name{{iftg=sort:name; }}	In Use{{iftg=sort:held; }}	Waiting{{iftg=sort:wait; }}
{{item=t001}}	{{ifne=i003;{{item=i003}}}}{{ifeq=i003; }}	{{ifne=i004;{{item=i004}}}}{{ifeq=i004; }}

{{ifeq=fram;{{tmpl=rbot}} {{tmpl=fbot}}

Report generated {{item=time}}. All times are GMT{{item=gmto}}.

{{item=admn}} ({{item=rtym}})

{{tmpl=bbot}}}}